# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年10月13日
"""
import pandas as pd

path = '../数据文件/课件026/分组聚合3.xlsx'
data = pd.read_excel(path,index_col=[0, 1])

data2 = data.groupby(level='班级').mean()

print(data2)
